ALTER TABLE Architects
ADD Firm VARCHAR(150)
GO
ALTER TABLE Architects
ADD [AddressLine] VARCHAR(150)
GO
ALTER TABLE Architects
ADD Phone VARCHAR(150)
GO
ALTER TABLE Architects
ADD Fax VARCHAR(150)
GO
ALTER TABLE Architects
ADD Email VARCHAR(150)
GO
ALTER TABLE Architects
ADD Website VARCHAR(150)
GO
ALTER TABLE Architects
ADD DescriptionLine VARCHAR(150)
GO
ALTER TABLE Architects
ADD NoOfEmployees VARCHAR(150)
GO
ALTER TABLE Architects
ADD FoundedYear VARCHAR(150)
GO
ALTER TABLE Architects
ADD Specialization VARCHAR(150)
GO
ALTER TABLE Architects
ADD Logo VARCHAR(150)
GO
ALTER TABLE Architects
DROP Column FirstName 
GO
ALTER TABLE Architects
DROP Column MiddleName 
GO
ALTER TABLE Architects
DROP Column LastName 
GO
ALTER TABLE Architects
DROP Column Gender 
GO
ALTER TABLE Architects
DROP Column DOB 
GO
ALTER TABLE Architects
DROP Column Biography 
GO
ALTER TABLE Architects
DROP Column SponsorTitle 
GO
ALTER TABLE Architects
DROP Column SponsorImage 
GO
ALTER TABLE Architects
DROP Column StateId 
GO
ALTER TABLE Architects
DROP Column CityId 
GO
ALTER TABLE Architects
DROP Column CountryId 
GO
ALTER TABLE Architects
DROP Column PropertyLocation 
GO
ALTER TABLE Architects
DROP Column [Image] 
GO
ALTER TABLE Architects
ADD PropertyLocation VARCHAR(150)
GO
ALTER TABLE Architects
ALTER Column DescriptionLine VARCHAR(MAX)
GO
DROP TABLE ArchitecturalFirms
GO

ALTER TABLE ArchitecturalWorks
DROP COLUMN [CityStateYear]
GO

ALTER TABLE ArchitecturalWorks
ADD [City] VARCHAR(100)
GO

ALTER TABLE ArchitecturalWorks
ADD [State] VARCHAR(100)
GO

ALTER TABLE ArchitecturalWorks
ADD [Year] VARCHAR(100)
GO

ALTER TABLE ArchitecturalWorks
ADD [ProjectImage] VARCHAR(100)
GO
ALTER TABLE Builders
DROP COLUMN PresenceIn
GO

ALTER TABLE Builders
DROP COLUMN HeadQuarter
GO

ALTER TABLE Builders
DROP COLUMN OnGoingProjects
GO

ALTER TABLE Builders
DROP COLUMN CompletedProjects
GO

ALTER TABLE Builders
DROP COLUMN IsActive
GO

ALTER TABLE Builders
DROP COLUMN StateId
GO

ALTER TABLE Builders
DROP COLUMN CityId
GO

ALTER TABLE Builders
DROP COLUMN CountryId
GO

ALTER TABLE Builders
ADD AddressLine VARCHAR(500)
GO

ALTER TABLE Builders
ADD Phone VARCHAR(50)
GO

ALTER TABLE Builders
ADD Fax VARCHAR(50)
GO

ALTER TABLE Builders
ADD Email VARCHAR(100)
GO

ALTER TABLE Builders
ADD Website VARCHAR(100)
GO